<?php 
unset($fieldspec);
 //fieldspec for employeeNumber

 //fieldspec for employeeNumber
$fieldspec["employeeNumber"] ["show"] = 1;
$fieldspec["employeeNumber"] ["key"] = 1;
$fieldspec["employeeNumber"] ["filter"] = 1;
$fieldspec["employeeNumber"] ["sort"] = 1;
$fieldspec["employeeNumber"] ["size"] = 20;
$fieldspec["employeeNumber"] ["rows"] = 1;
$fieldspec["employeeNumber"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["employeeNumber"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["employeeNumber"] ["source"] = "employees";
$fieldspec["employeeNumber"] ["edit_as"] = "ctl_text";

 //fieldspec for lastName

 //fieldspec for lastName
$fieldspec["lastName"] ["show"] = 1;
$fieldspec["lastName"] ["edit"] = 1;
$fieldspec["lastName"] ["filter"] = 1;
$fieldspec["lastName"] ["sort"] = 1;
$fieldspec["lastName"] ["size"] = 20;
$fieldspec["lastName"] ["rows"] = 1;
$fieldspec["lastName"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["lastName"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["lastName"] ["source"] = "employees";
$fieldspec["lastName"] ["edit_as"] = "ctl_text";
$fieldspec["lastName"] ["add"] = 1;

 //fieldspec for firstName

 //fieldspec for firstName
$fieldspec["firstName"] ["show"] = 1;
$fieldspec["firstName"] ["edit"] = 1;
$fieldspec["firstName"] ["filter"] = 1;
$fieldspec["firstName"] ["sort"] = 1;
$fieldspec["firstName"] ["size"] = 20;
$fieldspec["firstName"] ["rows"] = 1;
$fieldspec["firstName"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["firstName"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["firstName"] ["source"] = "employees";
$fieldspec["firstName"] ["edit_as"] = "ctl_text";

 //fieldspec for extension

 //fieldspec for extension
$fieldspec["extension"] ["show"] = 1;
$fieldspec["extension"] ["edit"] = 1;
$fieldspec["extension"] ["filter"] = 1;
$fieldspec["extension"] ["sort"] = 1;
$fieldspec["extension"] ["size"] = 20;
$fieldspec["extension"] ["rows"] = 1;
$fieldspec["extension"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["extension"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["extension"] ["source"] = "employees";
$fieldspec["extension"] ["edit_as"] = "ctl_text";

 //fieldspec for email

 //fieldspec for email
$fieldspec["email"] ["show"] = 1;
$fieldspec["email"] ["edit"] = 1;
$fieldspec["email"] ["filter"] = 1;
$fieldspec["email"] ["sort"] = 1;
$fieldspec["email"] ["size"] = 20;
$fieldspec["email"] ["rows"] = 1;
$fieldspec["email"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["email"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["email"] ["source"] = "employees";
$fieldspec["email"] ["edit_as"] = "ctl_text";

 //fieldspec for officeCode

 //fieldspec for officeCode
$fieldspec["officeCode"] ["show"] = 1;
$fieldspec["officeCode"] ["edit"] = 1;
$fieldspec["officeCode"] ["filter"] = 1;
$fieldspec["officeCode"] ["sort"] = 1;
$fieldspec["officeCode"] ["size"] = 20;
$fieldspec["officeCode"] ["rows"] = 1;
$fieldspec["officeCode"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["officeCode"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["officeCode"] ["source"] = "employees";
$fieldspec["officeCode"] ["edit_as"] = "ctl_select";
$fieldspec["officeCode"] ['showfilter'] = 1;
$fieldspec["officeCode"] ["listquery"] = "SELECT officeCode AS keyvalue, city AS showvalue FROM offices WHERE 1 ";

 //fieldspec for reportsTo

 //fieldspec for reportsTo
$fieldspec["reportsTo"] ["show"] = 1;
$fieldspec["reportsTo"] ["edit"] = 1;
$fieldspec["reportsTo"] ["filter"] = 1;
$fieldspec["reportsTo"] ["sort"] = 1;
$fieldspec["reportsTo"] ["size"] = 20;
$fieldspec["reportsTo"] ["rows"] = 1;
$fieldspec["reportsTo"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["reportsTo"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["reportsTo"] ["source"] = "employees";
$fieldspec["reportsTo"] ["edit_as"] = "ctl_select";
$fieldspec["reportsTo"] ["listquery"] = "SELECT employeeNumber AS keyvalue, lastName AS showvalue FROM employees WHERE 1=1 ";

 //fieldspec for jobTitle

 //fieldspec for jobTitle
$fieldspec["jobTitle"] ["show"] = 1;
$fieldspec["jobTitle"] ["edit"] = 1;
$fieldspec["jobTitle"] ["filter"] = 1;
$fieldspec["jobTitle"] ["sort"] = 1;
$fieldspec["jobTitle"] ["size"] = 20;
$fieldspec["jobTitle"] ["rows"] = 1;
$fieldspec["jobTitle"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["jobTitle"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["jobTitle"] ["source"] = "employees";
$fieldspec["jobTitle"] ["edit_as"] = "ctl_text";

 //fieldspec for fulltime

 //fieldspec for fulltime
$fieldspec["fulltime"] ["show"] = 1;
$fieldspec["fulltime"] ["edit"] = 1;
$fieldspec["fulltime"] ["filter"] = 1;
$fieldspec["fulltime"] ["sort"] = 1;
$fieldspec["fulltime"] ["size"] = 20;
$fieldspec["fulltime"] ["rows"] = 1;
$fieldspec["fulltime"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["fulltime"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["fulltime"] ["source"] = "employees";
$fieldspec["fulltime"] ["edit_as"] = "ctl_checkbox";

 //fieldspec for hiredate

 //fieldspec for hiredate
$fieldspec["hiredate"] ["show"] = 1;
$fieldspec["hiredate"] ["edit"] = 1;
$fieldspec["hiredate"] ["filter"] = 1;
$fieldspec["hiredate"] ["sort"] = 1;
$fieldspec["hiredate"] ["size"] = 20;
$fieldspec["hiredate"] ["rows"] = 1;
$fieldspec["hiredate"] ["date_show_format"] = "yyyy-mm-dd";
$fieldspec["hiredate"] ["date_source_format"] = "yyyy-mm-dd";
$fieldspec["hiredate"] ["source"] = "employees";
$fieldspec["hiredate"] ["edit_as"] = "ctl_jqdate";

//column settings for delete
$fieldspec['delete'] ['show'] = 1;
$fieldspec['delete'] ['size'] = 20;
$fieldspec['delete'] ['rows'] = 1;
$fieldspec['delete'] ['makefunction'] = 'make_delete';
 ?>